PC World Komputer 2010 April/PCWorld0410.iso/pluginy Firefox/5817/5817.xpi/chrome/content/menuSqlHelper.xul

Extensible Markup Language | 2010-02-11 | 6.4 KB | 119 lines

<?xml version="1.0"?>
<overlay id="tabDbInfo-overlay"
      xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul">

  <menubar id="sql-help-menubar">
    <menu id="sql-help-alter-menu" label="Select">
      <menupopup>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="SELECT * FROM tableName"
          value="SELECT * FROM tableName"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="SELECT with WHERE clause"
          value="SELECT [ALL | DISTINCT] result FROM table-list WHERE expr"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="SELECT (general)"
          value="SELECT [ALL | DISTINCT] result [FROM table-list] [WHERE expr] [GROUP BY expr-list] [HAVING expr] [compound-op select]* [ORDER BY sort-expr-list] [LIMIT integer [( OFFSET | , ) integer]]"/>
      </menupopup>
    </menu>
    <toolbarseparator/>
    <menu id="sql-help-drop-menu" label="Data Manipulation">
      <menupopup>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="DELETE"
          value="DELETE FROM tableName [WHERE expr]"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="INSERT values"
          value="INSERT INTO tableName [(column-list)] VALUES(value-list)"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="INSERT using select"
          value="INSERT INTO tableName [(column-list)] select-statement"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="UPDATE"
          value="UPDATE tableName SET assignment [, assignment]* [WHERE expr]"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="REPLACE values"
          value="REPLACE INTO tableName [(column-list)] VALUES(value-list)"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="REPLACE using select"
          value="REPLACE INTO tableName [(column-list)] select-statement"/>
      </menupopup>
    </menu>
    <toolbarseparator/>
    <menu id="sql-help-drop-menu" label="Create/Alter">
      <menupopup>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="CREATE TABLE"
          value="CREATE TABLE IF NOT EXISTS tableName (column-def [, column-def]* [, constraint]*"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="CREATE TEMP TABLE"
          value="CREATE TEMP TABLE IF NOT EXISTS tableName (column-def [, column-def]* [, constraint]*"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="CREATE TABLE x AS select-statement"
          value="CREATE TABLE tableName AS select-statement"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="CREATE TEMP TABLE x AS select-statement"
          value="CREATE TEMP TABLE tableName AS select-statement"/>
        <menuseparator/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="ALTER TABLE x RENAME TO y"
          value="ALTER TABLE old_tableName RENAME TO new_tableName"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="ALTER TABLE x ADD COLUMN column-def"
          value="ALTER TABLE x ADD COLUMN column-def"/>
        <menuseparator/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="CREATE INDEX"
          value="CREATE INDEX IF NOT EXISTS indexName ON tableName ( columnName [, columnName]* )"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="CREATE UNIQUE INDEX"
          value="CREATE UNIQUE INDEX IF NOT EXISTS indexName ON tableName ( columnName [, columnName]* )"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="CREATE VIEW"
          value="CREATE [TEMPORARY] VIEW IF NOT EXISTS viewName AS selectStatement"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="CREATE TRIGGER"
          value="CREATE [TEMPORARY] TRIGGER IF NOT EXISTS triggerName [ BEFORE | AFTER ] DELETE|INSERT|UPDATE ON tableName [ FOR EACH ROW ] [ WHEN expression ] BEGIN  semicolon-terminated-update-delete-select-or-insert-statements END"/>
      </menupopup>
    </menu>
    <toolbarseparator/>
    <menu id="sql-help-drop-menu" label="Drop">
      <menupopup>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="DROP TABLE" value="DROP TABLE tableName"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="DROP INDEX" value="DROP INDEX indexName"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="DROP VIEW" value="DROP VIEW viewName"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="DROP TRIGGER" value="DROP TRIGGER triggerName"/>
      </menupopup>
    </menu>
    <toolbarseparator/>
    <menu id="sql-help-drop-menu" label="ReIndex">
      <menupopup>
        <menuitem oncommand="SQLiteManager.setSqlText(this.label)" label="REINDEX tableName"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.label)" label="REINDEX indexName"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.label)" label="REINDEX collationName"/>
      </menupopup>
    </menu>
    <toolbarseparator/>
    <menu id="sql-help-pragma-menu" label="PRAGMA">
      <menupopup>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="PRAGMA table_info" value="PRAGMA table_info (tableName)"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="PRAGMA index_list" value="PRAGMA index_list (tableName)"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="PRAGMA foreign_key_list" value="PRAGMA foreign_key_list (tableName)"/>
        <menuseparator/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.value)"
          label="PRAGMA index_info" value="PRAGMA index_info (indexName)"/>
        <menuseparator/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.label)" label="PRAGMA database_list"/>
        <menuitem oncommand="SQLiteManager.setSqlText(this.label)" label="PRAGMA collation_list"/>
      </menupopup>
    </menu>
  </menubar>
</overlay>